home *** CD-ROM | disk | FTP | other *** search
/ Agent Central Host Computer / Agent - Central Host Computer.iso / _SETUP.1 / vbpmoney.sql < prev    next >
Text File  |  2000-05-12  |  463b  |  13 lines
  1. /*
  2. collects the Currency accepted and total cash ( cscurcnt) for a given probe, and cashbox.
  3. Outer join is needed because there is sometimes NO cash accepted since the previous probe.
  4. */
  5. create or replace view vbpmoney as
  6. select vsumcscurcnt.conversion_num, 
  7. vsumcscurcnt.close_count,
  8. vsumcscurcnt.cashbox_glid, 
  9. vsumcscurcnt.totalcash, 
  10. vsumcuracc.probedcash
  11. from vsumcscurcnt, vsumcuracc
  12. where vsumcscurcnt.close_count = vsumcuracc.close_count (+);
  13.